import java.sql.*;
public class java1001 {
    public static void main(String[] args) throws SQLException {
        Statement stmt = null;
        ResultSet rs = null;
        Connection conn = null;
        try{
            Class.forName("com.mysql.cj.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/jdbc?serverTimezone=GMT%2B8&useSSL=false";
            String username = "root";
            String password = "123456";
            try {
                conn = DriverManager.getConnection(url,username,password);
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                stmt = conn.createStatement();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            String sql = "select * from users";
            try {
                rs = stmt.executeQuery(sql);
            } catch (SQLException e) {
                e.printStackTrace();
            }
            System.out.println("id |  name |  password" + "  |  email      |  birthday");
            while (true){
                try {
                    if (!rs.next()) break;
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                int id = 0;
                try {
                    id = rs.getInt("id");
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                String name = null;
                try {
                    name = rs.getString("name");
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                String psw = null;
                try {
                    psw = rs.getString("password");
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                String email = null;
                try {
                    email = rs.getString("email");
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                Date birthday = null;
                try {
                    birthday = rs.getDate("birthday");
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                System.out.println(id + "    |" + name +"  |   " + psw +"   |    "  + email +"  |   " + birthday);
            }
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }finally {
            if (rs != null){
                try {
                    rs.close();
                }catch (SQLException e){
                    e.printStackTrace();
                }
                rs = null;
            }
            if (stmt !=null){
                try {
                    stmt.close();
                }catch (SQLException e){
                    e.printStackTrace();
                }
                stmt = null;
            }
            if(conn !=null);{
                try{
                    conn.close();
                }catch (SQLException e){
                    e.printStackTrace();
                }
                conn = null;
            }
        }
    }
}
